Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

Illegal mix of collations for operation 'in'
 
The error occurred in C:/inetpub/wwwroot/license-2-play/wholesale-toys/cfc/item.cfc: line 380
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm: line 82
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm: line 76
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm: line 1
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/controller.cfm: line 45
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/cfc/item.cfc: line 380
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm: line 82
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm: line 76
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm: line 1
Called from C:/inetpub/wwwroot/license-2-play/wholesale-toys/controller.cfm: line 45
 
378 : 			</cfif>
379 : 			<cfif arguments.durl neq "">
380 : 				and d_url in (<cfqueryparam cfsqltype="cf_sql_varchar" list="true" value="#arguments.durl#">)
381 : 			</cfif>
382 :     </cfquery>
SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   lic2
VENDORERRORCODE   1271
SQL   SELECT * FROM tbl_item_character_type WHERE 1=1 and d_status= (param 1) and d_url in ( (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) )
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   216.73.216.37
Referrer  
Date/Time   16-Oct-25 04:56 AM
Stack Trace
at cfitem2ecfc1348890498$funcGETITEMCHARACTERTYPE.runFunction(C:/inetpub/wwwroot/license-2-play/wholesale-toys/cfc/item.cfc:380) at cfproduct2dlist2ecfm522815963._factor0(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm:82) at cfproduct2dlist2ecfm522815963._factor13(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm:76) at cfproduct2dlist2ecfm522815963.runPage(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm:1) at cfcontroller2ecfm1692613691.runPage(C:/inetpub/wwwroot/license-2-play/wholesale-toys/controller.cfm:45) at cfitem2ecfc1348890498$funcGETITEMCHARACTERTYPE.runFunction(C:/inetpub/wwwroot/license-2-play/wholesale-toys/cfc/item.cfc:380) at cfproduct2dlist2ecfm522815963._factor0(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm:82) at cfproduct2dlist2ecfm522815963._factor13(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm:76) at cfproduct2dlist2ecfm522815963.runPage(C:/inetpub/wwwroot/license-2-play/wholesale-toys/product-list.cfm:1) at cfcontroller2ecfm1692613691.runPage(C:/inetpub/wwwroot/license-2-play/wholesale-toys/controller.cfm:45) 

java.sql.SQLException: Illegal mix of collations for operation 'in'
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1665)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1391)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1321)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cfitem2ecfc1348890498$funcGETITEMCHARACTERTYPE.runFunction(C:\inetpub\wwwroot\license-2-play\wholesale-toys\cfc\item.cfc:380)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012)
	at cfproduct2dlist2ecfm522815963._factor0(C:\inetpub\wwwroot\license-2-play\wholesale-toys\product-list.cfm:82)
	at cfproduct2dlist2ecfm522815963._factor13(C:\inetpub\wwwroot\license-2-play\wholesale-toys\product-list.cfm:76)
	at cfproduct2dlist2ecfm522815963.runPage(C:\inetpub\wwwroot\license-2-play\wholesale-toys\product-list.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
	at cfcontroller2ecfm1692613691.runPage(C:\inetpub\wwwroot\license-2-play\wholesale-toys\controller.cfm:45)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
	at java.base/java.lang.Thread.run(Thread.java:833)